{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "import QUANTAXIS as QA"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "## 下面是东方财务通财务分析的爬虫"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "data=QA.QAFetch.QAEastMoney.QA_fetch_get_stock_analysis('600010')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ms</th>\n",
       "      <th>rq</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>生产、销售:黑色金属及其延压加工产品、冶金机械、设备及配件,焦炭及焦化副产品(化工)生产和销...</td>\n",
       "      <td>none</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  ms    rq\n",
       "0  生产、销售:黑色金属及其延压加工产品、冶金机械、设备及配件,焦炭及焦化副产品(化工)生产和销...  none"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>gpdm</th>\n",
       "      <th>ms</th>\n",
       "      <th>rq</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>60001001</td>\n",
       "      <td>2017年以来,公司坚持稳中求进总基调,以“降本增效”为抓手,积极应对市场变化,保持生产经营...</td>\n",
       "      <td>2017/6/30 0:00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       gpdm                                                 ms  \\\n",
       "0  60001001  2017年以来,公司坚持稳中求进总基调,以“降本增效”为抓手,积极应对市场变化,保持生产经营...   \n",
       "\n",
       "                  rq  \n",
       "0  2017/6/30 0:00:00  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>cbbl</th>\n",
       "      <th>dw</th>\n",
       "      <th>lrbl</th>\n",
       "      <th>mll</th>\n",
       "      <th>orderby</th>\n",
       "      <th>rq</th>\n",
       "      <th>srbl</th>\n",
       "      <th>zycb</th>\n",
       "      <th>zygc</th>\n",
       "      <th>zylr</th>\n",
       "      <th>zysr</th>\n",
       "      <th>date</th>\n",
       "      <th>classify</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th>classify</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"16\" valign=\"top\">2016-12-31</th>\n",
       "      <th>hy</th>\n",
       "      <td>98.60%</td>\n",
       "      <td>元</td>\n",
       "      <td>100.07%</td>\n",
       "      <td>8.72%</td>\n",
       "      <td>3.063367e+10</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>98.73%</td>\n",
       "      <td>279.63亿</td>\n",
       "      <td>冶金行业</td>\n",
       "      <td>26.71亿</td>\n",
       "      <td>306.34亿</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>hy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hy</th>\n",
       "      <td>1.40%</td>\n",
       "      <td>元</td>\n",
       "      <td>-0.07%</td>\n",
       "      <td>-0.49%</td>\n",
       "      <td>3.945096e+08</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>1.27%</td>\n",
       "      <td>3.96亿</td>\n",
       "      <td>其他(补充)</td>\n",
       "      <td>-192.48万</td>\n",
       "      <td>3.95亿</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>hy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cp</th>\n",
       "      <td>50.92%</td>\n",
       "      <td>元</td>\n",
       "      <td>38.49%</td>\n",
       "      <td>6.64%</td>\n",
       "      <td>1.546645e+10</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>49.85%</td>\n",
       "      <td>144.39亿</td>\n",
       "      <td>板材</td>\n",
       "      <td>10.27亿</td>\n",
       "      <td>154.66亿</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>cp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cp</th>\n",
       "      <td>20.67%</td>\n",
       "      <td>元</td>\n",
       "      <td>34.65%</td>\n",
       "      <td>13.63%</td>\n",
       "      <td>6.786366e+09</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>21.87%</td>\n",
       "      <td>58.62亿</td>\n",
       "      <td>型材</td>\n",
       "      <td>9.25亿</td>\n",
       "      <td>67.86亿</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>cp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cp</th>\n",
       "      <td>12.74%</td>\n",
       "      <td>元</td>\n",
       "      <td>-10.83%</td>\n",
       "      <td>-8.70%</td>\n",
       "      <td>3.322457e+09</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>10.71%</td>\n",
       "      <td>36.12亿</td>\n",
       "      <td>管材</td>\n",
       "      <td>-2.89亿</td>\n",
       "      <td>33.22亿</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>cp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cp</th>\n",
       "      <td>7.96%</td>\n",
       "      <td>元</td>\n",
       "      <td>33.56%</td>\n",
       "      <td>28.40%</td>\n",
       "      <td>3.153979e+09</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>10.16%</td>\n",
       "      <td>22.58亿</td>\n",
       "      <td>其他(补充)</td>\n",
       "      <td>8.96亿</td>\n",
       "      <td>31.54亿</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>cp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cp</th>\n",
       "      <td>7.72%</td>\n",
       "      <td>元</td>\n",
       "      <td>4.13%</td>\n",
       "      <td>4.80%</td>\n",
       "      <td>2.298927e+09</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>7.41%</td>\n",
       "      <td>21.89亿</td>\n",
       "      <td>线棒材</td>\n",
       "      <td>1.10亿</td>\n",
       "      <td>22.99亿</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>cp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>52.15%</td>\n",
       "      <td>元</td>\n",
       "      <td>45.07%</td>\n",
       "      <td>7.52%</td>\n",
       "      <td>1.599290e+10</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>51.54%</td>\n",
       "      <td>147.90亿</td>\n",
       "      <td>华北地区</td>\n",
       "      <td>12.03亿</td>\n",
       "      <td>159.93亿</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>18.59%</td>\n",
       "      <td>元</td>\n",
       "      <td>23.21%</td>\n",
       "      <td>10.52%</td>\n",
       "      <td>5.891463e+09</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>18.99%</td>\n",
       "      <td>52.72亿</td>\n",
       "      <td>华东地区</td>\n",
       "      <td>6.19亿</td>\n",
       "      <td>58.91亿</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>12.02%</td>\n",
       "      <td>元</td>\n",
       "      <td>12.14%</td>\n",
       "      <td>8.68%</td>\n",
       "      <td>3.732813e+09</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>12.03%</td>\n",
       "      <td>34.09亿</td>\n",
       "      <td>出口</td>\n",
       "      <td>3.24亿</td>\n",
       "      <td>37.33亿</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>7.06%</td>\n",
       "      <td>元</td>\n",
       "      <td>10.66%</td>\n",
       "      <td>12.44%</td>\n",
       "      <td>2.287516e+09</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>7.37%</td>\n",
       "      <td>20.03亿</td>\n",
       "      <td>西北地区</td>\n",
       "      <td>2.84亿</td>\n",
       "      <td>22.88亿</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>2.92%</td>\n",
       "      <td>元</td>\n",
       "      <td>1.65%</td>\n",
       "      <td>5.04%</td>\n",
       "      <td>8.720447e+08</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>2.81%</td>\n",
       "      <td>8.28亿</td>\n",
       "      <td>东北地区</td>\n",
       "      <td>4399.01万</td>\n",
       "      <td>8.72亿</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>2.67%</td>\n",
       "      <td>元</td>\n",
       "      <td>3.43%</td>\n",
       "      <td>10.79%</td>\n",
       "      <td>8.473853e+08</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>2.73%</td>\n",
       "      <td>7.56亿</td>\n",
       "      <td>华南地区</td>\n",
       "      <td>9144.31万</td>\n",
       "      <td>8.47亿</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>1.70%</td>\n",
       "      <td>元</td>\n",
       "      <td>2.35%</td>\n",
       "      <td>11.47%</td>\n",
       "      <td>5.459773e+08</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>1.76%</td>\n",
       "      <td>4.83亿</td>\n",
       "      <td>西南地区</td>\n",
       "      <td>6263.22万</td>\n",
       "      <td>5.46亿</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>1.49%</td>\n",
       "      <td>元</td>\n",
       "      <td>1.57%</td>\n",
       "      <td>9.03%</td>\n",
       "      <td>4.635695e+08</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>1.49%</td>\n",
       "      <td>4.22亿</td>\n",
       "      <td>中南地区</td>\n",
       "      <td>4187.34万</td>\n",
       "      <td>4.64亿</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>1.40%</td>\n",
       "      <td>元</td>\n",
       "      <td>-0.07%</td>\n",
       "      <td>-0.49%</td>\n",
       "      <td>3.945096e+08</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>1.27%</td>\n",
       "      <td>3.96亿</td>\n",
       "      <td>其他(补充)</td>\n",
       "      <td>-192.48万</td>\n",
       "      <td>3.95亿</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"14\" valign=\"top\">2016-06-30</th>\n",
       "      <th>hy</th>\n",
       "      <td>97.66%</td>\n",
       "      <td>元</td>\n",
       "      <td>94.62%</td>\n",
       "      <td>4.99%</td>\n",
       "      <td>1.173666e+10</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>97.50%</td>\n",
       "      <td>111.51亿</td>\n",
       "      <td>冶金行业</td>\n",
       "      <td>5.86亿</td>\n",
       "      <td>117.37亿</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>hy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hy</th>\n",
       "      <td>2.34%</td>\n",
       "      <td>元</td>\n",
       "      <td>5.38%</td>\n",
       "      <td>11.08%</td>\n",
       "      <td>3.004639e+08</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>2.50%</td>\n",
       "      <td>2.67亿</td>\n",
       "      <td>其他(补充)</td>\n",
       "      <td>3329.90万</td>\n",
       "      <td>3.00亿</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>hy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cp</th>\n",
       "      <td>64.72%</td>\n",
       "      <td>元</td>\n",
       "      <td>43.47%</td>\n",
       "      <td>2.90%</td>\n",
       "      <td>7.398011e+09</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>63.82%</td>\n",
       "      <td>71.84亿</td>\n",
       "      <td>板材</td>\n",
       "      <td>2.14亿</td>\n",
       "      <td>73.98亿</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>cp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cp</th>\n",
       "      <td>14.20%</td>\n",
       "      <td>元</td>\n",
       "      <td>80.18%</td>\n",
       "      <td>20.06%</td>\n",
       "      <td>1.970952e+09</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>17.00%</td>\n",
       "      <td>15.76亿</td>\n",
       "      <td>型材</td>\n",
       "      <td>3.95亿</td>\n",
       "      <td>19.71亿</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>cp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cp</th>\n",
       "      <td>12.21%</td>\n",
       "      <td>元</td>\n",
       "      <td>-25.25%</td>\n",
       "      <td>-10.11%</td>\n",
       "      <td>1.230897e+09</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>10.62%</td>\n",
       "      <td>13.55亿</td>\n",
       "      <td>管材</td>\n",
       "      <td>-1.25亿</td>\n",
       "      <td>12.31亿</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>cp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cp</th>\n",
       "      <td>8.87%</td>\n",
       "      <td>元</td>\n",
       "      <td>1.60%</td>\n",
       "      <td>0.79%</td>\n",
       "      <td>9.925784e+08</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>8.56%</td>\n",
       "      <td>9.85亿</td>\n",
       "      <td>线棒材</td>\n",
       "      <td>787.41万</td>\n",
       "      <td>9.93亿</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>cp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>6.419758e+09</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>53.33%</td>\n",
       "      <td>--</td>\n",
       "      <td>华北地区</td>\n",
       "      <td>--</td>\n",
       "      <td>64.20亿</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>2.145682e+09</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>17.83%</td>\n",
       "      <td>--</td>\n",
       "      <td>华东地区</td>\n",
       "      <td>--</td>\n",
       "      <td>21.46亿</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>9.481184e+08</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>7.88%</td>\n",
       "      <td>--</td>\n",
       "      <td>出口</td>\n",
       "      <td>--</td>\n",
       "      <td>9.48亿</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>9.397453e+08</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>7.81%</td>\n",
       "      <td>--</td>\n",
       "      <td>西北地区</td>\n",
       "      <td>--</td>\n",
       "      <td>9.40亿</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>3.482142e+08</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>2.89%</td>\n",
       "      <td>--</td>\n",
       "      <td>华南地区</td>\n",
       "      <td>--</td>\n",
       "      <td>3.48亿</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>3.410445e+08</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>2.83%</td>\n",
       "      <td>--</td>\n",
       "      <td>中南地区</td>\n",
       "      <td>--</td>\n",
       "      <td>3.41亿</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>3.079160e+08</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>2.56%</td>\n",
       "      <td>--</td>\n",
       "      <td>西南地区</td>\n",
       "      <td>--</td>\n",
       "      <td>3.08亿</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>3.004639e+08</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>2.50%</td>\n",
       "      <td>--</td>\n",
       "      <td>其他(补充)</td>\n",
       "      <td>--</td>\n",
       "      <td>3.00亿</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">2015-12-31</th>\n",
       "      <th>qy</th>\n",
       "      <td>4.14%</td>\n",
       "      <td>元</td>\n",
       "      <td>2.92%</td>\n",
       "      <td>-9.64%</td>\n",
       "      <td>9.718405e+08</td>\n",
       "      <td>2015-12-31</td>\n",
       "      <td>4.32%</td>\n",
       "      <td>10.66亿</td>\n",
       "      <td>西南</td>\n",
       "      <td>-9370.44万</td>\n",
       "      <td>9.72亿</td>\n",
       "      <td>2015-12-31</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>2.70%</td>\n",
       "      <td>元</td>\n",
       "      <td>2.48%</td>\n",
       "      <td>-12.95%</td>\n",
       "      <td>6.151942e+08</td>\n",
       "      <td>2015-12-31</td>\n",
       "      <td>2.73%</td>\n",
       "      <td>6.95亿</td>\n",
       "      <td>中南</td>\n",
       "      <td>-7968.61万</td>\n",
       "      <td>6.15亿</td>\n",
       "      <td>2015-12-31</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>1.21%</td>\n",
       "      <td>元</td>\n",
       "      <td>-5.42%</td>\n",
       "      <td>35.87%</td>\n",
       "      <td>4.846532e+08</td>\n",
       "      <td>2015-12-31</td>\n",
       "      <td>2.15%</td>\n",
       "      <td>3.11亿</td>\n",
       "      <td>其他(补充)</td>\n",
       "      <td>1.74亿</td>\n",
       "      <td>4.85亿</td>\n",
       "      <td>2015-12-31</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"13\" valign=\"top\">2015-06-30</th>\n",
       "      <th>hy</th>\n",
       "      <td>100.00%</td>\n",
       "      <td>元</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>4.68%</td>\n",
       "      <td>1.149661e+10</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>109.59亿</td>\n",
       "      <td>冶金行业</td>\n",
       "      <td>5.38亿</td>\n",
       "      <td>114.97亿</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>hy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cp</th>\n",
       "      <td>48.93%</td>\n",
       "      <td>元</td>\n",
       "      <td>-15.16%</td>\n",
       "      <td>-1.45%</td>\n",
       "      <td>4.719596e+09</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>46.10%</td>\n",
       "      <td>47.88亿</td>\n",
       "      <td>板材</td>\n",
       "      <td>-6862.02万</td>\n",
       "      <td>47.20亿</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>cp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cp</th>\n",
       "      <td>21.94%</td>\n",
       "      <td>元</td>\n",
       "      <td>126.12%</td>\n",
       "      <td>21.00%</td>\n",
       "      <td>2.718051e+09</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>26.55%</td>\n",
       "      <td>21.47亿</td>\n",
       "      <td>型材</td>\n",
       "      <td>5.71亿</td>\n",
       "      <td>27.18亿</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>cp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cp</th>\n",
       "      <td>15.62%</td>\n",
       "      <td>元</td>\n",
       "      <td>-3.23%</td>\n",
       "      <td>-0.97%</td>\n",
       "      <td>1.513849e+09</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>14.79%</td>\n",
       "      <td>15.28亿</td>\n",
       "      <td>管材</td>\n",
       "      <td>-1461.12万</td>\n",
       "      <td>15.14亿</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>cp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cp</th>\n",
       "      <td>13.50%</td>\n",
       "      <td>元</td>\n",
       "      <td>-7.73%</td>\n",
       "      <td>-2.72%</td>\n",
       "      <td>1.286317e+09</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>12.56%</td>\n",
       "      <td>13.21亿</td>\n",
       "      <td>线棒材</td>\n",
       "      <td>-3497.08万</td>\n",
       "      <td>12.86亿</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>cp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>4.189974e+09</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>37.32%</td>\n",
       "      <td>--</td>\n",
       "      <td>华北地区</td>\n",
       "      <td>--</td>\n",
       "      <td>41.90亿</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>2.636873e+09</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>23.49%</td>\n",
       "      <td>--</td>\n",
       "      <td>华东地区</td>\n",
       "      <td>--</td>\n",
       "      <td>26.37亿</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>1.416055e+09</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>12.61%</td>\n",
       "      <td>--</td>\n",
       "      <td>出口</td>\n",
       "      <td>--</td>\n",
       "      <td>14.16亿</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>1.308914e+09</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>11.66%</td>\n",
       "      <td>--</td>\n",
       "      <td>西北地区</td>\n",
       "      <td>--</td>\n",
       "      <td>13.09亿</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>5.137076e+08</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>4.58%</td>\n",
       "      <td>--</td>\n",
       "      <td>东北地区</td>\n",
       "      <td>--</td>\n",
       "      <td>5.14亿</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>4.734898e+08</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>4.22%</td>\n",
       "      <td>--</td>\n",
       "      <td>西南地区</td>\n",
       "      <td>--</td>\n",
       "      <td>4.73亿</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>3.717321e+08</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>3.31%</td>\n",
       "      <td>--</td>\n",
       "      <td>华南地区</td>\n",
       "      <td>--</td>\n",
       "      <td>3.72亿</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>3.162873e+08</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>2.82%</td>\n",
       "      <td>--</td>\n",
       "      <td>中南地区</td>\n",
       "      <td>--</td>\n",
       "      <td>3.16亿</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"14\" valign=\"top\">2014-12-31</th>\n",
       "      <th>hy</th>\n",
       "      <td>95.76%</td>\n",
       "      <td>元</td>\n",
       "      <td>93.14%</td>\n",
       "      <td>10.64%</td>\n",
       "      <td>2.844250e+10</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>95.47%</td>\n",
       "      <td>254.17亿</td>\n",
       "      <td>冶金行业</td>\n",
       "      <td>30.26亿</td>\n",
       "      <td>284.43亿</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>hy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hy</th>\n",
       "      <td>4.24%</td>\n",
       "      <td>元</td>\n",
       "      <td>6.86%</td>\n",
       "      <td>16.51%</td>\n",
       "      <td>1.349392e+09</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>4.53%</td>\n",
       "      <td>11.27亿</td>\n",
       "      <td>其他(补充)</td>\n",
       "      <td>2.23亿</td>\n",
       "      <td>13.49亿</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>hy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cp</th>\n",
       "      <td>46.97%</td>\n",
       "      <td>元</td>\n",
       "      <td>27.73%</td>\n",
       "      <td>6.61%</td>\n",
       "      <td>1.214046e+10</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>44.91%</td>\n",
       "      <td>113.38亿</td>\n",
       "      <td>板材</td>\n",
       "      <td>8.03亿</td>\n",
       "      <td>121.40亿</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>cp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cp</th>\n",
       "      <td>17.83%</td>\n",
       "      <td>元</td>\n",
       "      <td>58.53%</td>\n",
       "      <td>28.25%</td>\n",
       "      <td>5.996408e+09</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>22.18%</td>\n",
       "      <td>43.03亿</td>\n",
       "      <td>型材</td>\n",
       "      <td>16.94亿</td>\n",
       "      <td>59.96亿</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>cp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cp</th>\n",
       "      <td>18.28%</td>\n",
       "      <td>元</td>\n",
       "      <td>9.01%</td>\n",
       "      <td>5.58%</td>\n",
       "      <td>4.673397e+09</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>17.29%</td>\n",
       "      <td>44.13亿</td>\n",
       "      <td>线棒材</td>\n",
       "      <td>2.61亿</td>\n",
       "      <td>46.73亿</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>cp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cp</th>\n",
       "      <td>16.92%</td>\n",
       "      <td>元</td>\n",
       "      <td>4.72%</td>\n",
       "      <td>3.24%</td>\n",
       "      <td>4.221141e+09</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>15.62%</td>\n",
       "      <td>40.84亿</td>\n",
       "      <td>管材</td>\n",
       "      <td>1.37亿</td>\n",
       "      <td>42.21亿</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>cp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>9.918000e+09</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>34.87%</td>\n",
       "      <td>--</td>\n",
       "      <td>华北地区</td>\n",
       "      <td>--</td>\n",
       "      <td>99.18亿</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>6.220000e+09</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>21.87%</td>\n",
       "      <td>--</td>\n",
       "      <td>华东地区</td>\n",
       "      <td>--</td>\n",
       "      <td>62.20亿</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>4.858000e+09</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>17.08%</td>\n",
       "      <td>--</td>\n",
       "      <td>出口</td>\n",
       "      <td>--</td>\n",
       "      <td>48.58亿</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>2.807000e+09</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>9.87%</td>\n",
       "      <td>--</td>\n",
       "      <td>西北地区</td>\n",
       "      <td>--</td>\n",
       "      <td>28.07亿</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>1.544000e+09</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>5.43%</td>\n",
       "      <td>--</td>\n",
       "      <td>华南地区</td>\n",
       "      <td>--</td>\n",
       "      <td>15.44亿</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>1.186000e+09</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>4.17%</td>\n",
       "      <td>--</td>\n",
       "      <td>东北地区</td>\n",
       "      <td>--</td>\n",
       "      <td>11.86亿</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>1.169000e+09</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>4.11%</td>\n",
       "      <td>--</td>\n",
       "      <td>西南地区</td>\n",
       "      <td>--</td>\n",
       "      <td>11.69亿</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qy</th>\n",
       "      <td>--</td>\n",
       "      <td>元</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>7.400000e+08</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>2.60%</td>\n",
       "      <td>--</td>\n",
       "      <td>中南地区</td>\n",
       "      <td>--</td>\n",
       "      <td>7.40亿</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>qy</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>73 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        cbbl dw     lrbl      mll       orderby          rq  \\\n",
       "date       classify                                                           \n",
       "2016-12-31 hy         98.60%  元  100.07%    8.72%  3.063367e+10  2016-12-31   \n",
       "           hy          1.40%  元   -0.07%   -0.49%  3.945096e+08  2016-12-31   \n",
       "           cp         50.92%  元   38.49%    6.64%  1.546645e+10  2016-12-31   \n",
       "           cp         20.67%  元   34.65%   13.63%  6.786366e+09  2016-12-31   \n",
       "           cp         12.74%  元  -10.83%   -8.70%  3.322457e+09  2016-12-31   \n",
       "           cp          7.96%  元   33.56%   28.40%  3.153979e+09  2016-12-31   \n",
       "           cp          7.72%  元    4.13%    4.80%  2.298927e+09  2016-12-31   \n",
       "           qy         52.15%  元   45.07%    7.52%  1.599290e+10  2016-12-31   \n",
       "           qy         18.59%  元   23.21%   10.52%  5.891463e+09  2016-12-31   \n",
       "           qy         12.02%  元   12.14%    8.68%  3.732813e+09  2016-12-31   \n",
       "           qy          7.06%  元   10.66%   12.44%  2.287516e+09  2016-12-31   \n",
       "           qy          2.92%  元    1.65%    5.04%  8.720447e+08  2016-12-31   \n",
       "           qy          2.67%  元    3.43%   10.79%  8.473853e+08  2016-12-31   \n",
       "           qy          1.70%  元    2.35%   11.47%  5.459773e+08  2016-12-31   \n",
       "           qy          1.49%  元    1.57%    9.03%  4.635695e+08  2016-12-31   \n",
       "           qy          1.40%  元   -0.07%   -0.49%  3.945096e+08  2016-12-31   \n",
       "2016-06-30 hy         97.66%  元   94.62%    4.99%  1.173666e+10  2016-06-30   \n",
       "           hy          2.34%  元    5.38%   11.08%  3.004639e+08  2016-06-30   \n",
       "           cp         64.72%  元   43.47%    2.90%  7.398011e+09  2016-06-30   \n",
       "           cp         14.20%  元   80.18%   20.06%  1.970952e+09  2016-06-30   \n",
       "           cp         12.21%  元  -25.25%  -10.11%  1.230897e+09  2016-06-30   \n",
       "           cp          8.87%  元    1.60%    0.79%  9.925784e+08  2016-06-30   \n",
       "           qy             --  元       --       --  6.419758e+09  2016-06-30   \n",
       "           qy             --  元       --       --  2.145682e+09  2016-06-30   \n",
       "           qy             --  元       --       --  9.481184e+08  2016-06-30   \n",
       "           qy             --  元       --       --  9.397453e+08  2016-06-30   \n",
       "           qy             --  元       --       --  3.482142e+08  2016-06-30   \n",
       "           qy             --  元       --       --  3.410445e+08  2016-06-30   \n",
       "           qy             --  元       --       --  3.079160e+08  2016-06-30   \n",
       "           qy             --  元       --       --  3.004639e+08  2016-06-30   \n",
       "...                      ... ..      ...      ...           ...         ...   \n",
       "2015-12-31 qy          4.14%  元    2.92%   -9.64%  9.718405e+08  2015-12-31   \n",
       "           qy          2.70%  元    2.48%  -12.95%  6.151942e+08  2015-12-31   \n",
       "           qy          1.21%  元   -5.42%   35.87%  4.846532e+08  2015-12-31   \n",
       "2015-06-30 hy        100.00%  元  100.00%    4.68%  1.149661e+10  2015-06-30   \n",
       "           cp         48.93%  元  -15.16%   -1.45%  4.719596e+09  2015-06-30   \n",
       "           cp         21.94%  元  126.12%   21.00%  2.718051e+09  2015-06-30   \n",
       "           cp         15.62%  元   -3.23%   -0.97%  1.513849e+09  2015-06-30   \n",
       "           cp         13.50%  元   -7.73%   -2.72%  1.286317e+09  2015-06-30   \n",
       "           qy             --  元       --       --  4.189974e+09  2015-06-30   \n",
       "           qy             --  元       --       --  2.636873e+09  2015-06-30   \n",
       "           qy             --  元       --       --  1.416055e+09  2015-06-30   \n",
       "           qy             --  元       --       --  1.308914e+09  2015-06-30   \n",
       "           qy             --  元       --       --  5.137076e+08  2015-06-30   \n",
       "           qy             --  元       --       --  4.734898e+08  2015-06-30   \n",
       "           qy             --  元       --       --  3.717321e+08  2015-06-30   \n",
       "           qy             --  元       --       --  3.162873e+08  2015-06-30   \n",
       "2014-12-31 hy         95.76%  元   93.14%   10.64%  2.844250e+10  2014-12-31   \n",
       "           hy          4.24%  元    6.86%   16.51%  1.349392e+09  2014-12-31   \n",
       "           cp         46.97%  元   27.73%    6.61%  1.214046e+10  2014-12-31   \n",
       "           cp         17.83%  元   58.53%   28.25%  5.996408e+09  2014-12-31   \n",
       "           cp         18.28%  元    9.01%    5.58%  4.673397e+09  2014-12-31   \n",
       "           cp         16.92%  元    4.72%    3.24%  4.221141e+09  2014-12-31   \n",
       "           qy             --  元       --       --  9.918000e+09  2014-12-31   \n",
       "           qy             --  元       --       --  6.220000e+09  2014-12-31   \n",
       "           qy             --  元       --       --  4.858000e+09  2014-12-31   \n",
       "           qy             --  元       --       --  2.807000e+09  2014-12-31   \n",
       "           qy             --  元       --       --  1.544000e+09  2014-12-31   \n",
       "           qy             --  元       --       --  1.186000e+09  2014-12-31   \n",
       "           qy             --  元       --       --  1.169000e+09  2014-12-31   \n",
       "           qy             --  元       --       --  7.400000e+08  2014-12-31   \n",
       "\n",
       "                        srbl     zycb    zygc       zylr     zysr        date  \\\n",
       "date       classify                                                             \n",
       "2016-12-31 hy         98.73%  279.63亿    冶金行业     26.71亿  306.34亿  2016-12-31   \n",
       "           hy          1.27%    3.96亿  其他(补充)   -192.48万    3.95亿  2016-12-31   \n",
       "           cp         49.85%  144.39亿      板材     10.27亿  154.66亿  2016-12-31   \n",
       "           cp         21.87%   58.62亿      型材      9.25亿   67.86亿  2016-12-31   \n",
       "           cp         10.71%   36.12亿      管材     -2.89亿   33.22亿  2016-12-31   \n",
       "           cp         10.16%   22.58亿  其他(补充)      8.96亿   31.54亿  2016-12-31   \n",
       "           cp          7.41%   21.89亿     线棒材      1.10亿   22.99亿  2016-12-31   \n",
       "           qy         51.54%  147.90亿    华北地区     12.03亿  159.93亿  2016-12-31   \n",
       "           qy         18.99%   52.72亿    华东地区      6.19亿   58.91亿  2016-12-31   \n",
       "           qy         12.03%   34.09亿      出口      3.24亿   37.33亿  2016-12-31   \n",
       "           qy          7.37%   20.03亿    西北地区      2.84亿   22.88亿  2016-12-31   \n",
       "           qy          2.81%    8.28亿    东北地区   4399.01万    8.72亿  2016-12-31   \n",
       "           qy          2.73%    7.56亿    华南地区   9144.31万    8.47亿  2016-12-31   \n",
       "           qy          1.76%    4.83亿    西南地区   6263.22万    5.46亿  2016-12-31   \n",
       "           qy          1.49%    4.22亿    中南地区   4187.34万    4.64亿  2016-12-31   \n",
       "           qy          1.27%    3.96亿  其他(补充)   -192.48万    3.95亿  2016-12-31   \n",
       "2016-06-30 hy         97.50%  111.51亿    冶金行业      5.86亿  117.37亿  2016-06-30   \n",
       "           hy          2.50%    2.67亿  其他(补充)   3329.90万    3.00亿  2016-06-30   \n",
       "           cp         63.82%   71.84亿      板材      2.14亿   73.98亿  2016-06-30   \n",
       "           cp         17.00%   15.76亿      型材      3.95亿   19.71亿  2016-06-30   \n",
       "           cp         10.62%   13.55亿      管材     -1.25亿   12.31亿  2016-06-30   \n",
       "           cp          8.56%    9.85亿     线棒材    787.41万    9.93亿  2016-06-30   \n",
       "           qy         53.33%       --    华北地区         --   64.20亿  2016-06-30   \n",
       "           qy         17.83%       --    华东地区         --   21.46亿  2016-06-30   \n",
       "           qy          7.88%       --      出口         --    9.48亿  2016-06-30   \n",
       "           qy          7.81%       --    西北地区         --    9.40亿  2016-06-30   \n",
       "           qy          2.89%       --    华南地区         --    3.48亿  2016-06-30   \n",
       "           qy          2.83%       --    中南地区         --    3.41亿  2016-06-30   \n",
       "           qy          2.56%       --    西南地区         --    3.08亿  2016-06-30   \n",
       "           qy          2.50%       --  其他(补充)         --    3.00亿  2016-06-30   \n",
       "...                      ...      ...     ...        ...      ...         ...   \n",
       "2015-12-31 qy          4.32%   10.66亿      西南  -9370.44万    9.72亿  2015-12-31   \n",
       "           qy          2.73%    6.95亿      中南  -7968.61万    6.15亿  2015-12-31   \n",
       "           qy          2.15%    3.11亿  其他(补充)      1.74亿    4.85亿  2015-12-31   \n",
       "2015-06-30 hy        100.00%  109.59亿    冶金行业      5.38亿  114.97亿  2015-06-30   \n",
       "           cp         46.10%   47.88亿      板材  -6862.02万   47.20亿  2015-06-30   \n",
       "           cp         26.55%   21.47亿      型材      5.71亿   27.18亿  2015-06-30   \n",
       "           cp         14.79%   15.28亿      管材  -1461.12万   15.14亿  2015-06-30   \n",
       "           cp         12.56%   13.21亿     线棒材  -3497.08万   12.86亿  2015-06-30   \n",
       "           qy         37.32%       --    华北地区         --   41.90亿  2015-06-30   \n",
       "           qy         23.49%       --    华东地区         --   26.37亿  2015-06-30   \n",
       "           qy         12.61%       --      出口         --   14.16亿  2015-06-30   \n",
       "           qy         11.66%       --    西北地区         --   13.09亿  2015-06-30   \n",
       "           qy          4.58%       --    东北地区         --    5.14亿  2015-06-30   \n",
       "           qy          4.22%       --    西南地区         --    4.73亿  2015-06-30   \n",
       "           qy          3.31%       --    华南地区         --    3.72亿  2015-06-30   \n",
       "           qy          2.82%       --    中南地区         --    3.16亿  2015-06-30   \n",
       "2014-12-31 hy         95.47%  254.17亿    冶金行业     30.26亿  284.43亿  2014-12-31   \n",
       "           hy          4.53%   11.27亿  其他(补充)      2.23亿   13.49亿  2014-12-31   \n",
       "           cp         44.91%  113.38亿      板材      8.03亿  121.40亿  2014-12-31   \n",
       "           cp         22.18%   43.03亿      型材     16.94亿   59.96亿  2014-12-31   \n",
       "           cp         17.29%   44.13亿     线棒材      2.61亿   46.73亿  2014-12-31   \n",
       "           cp         15.62%   40.84亿      管材      1.37亿   42.21亿  2014-12-31   \n",
       "           qy         34.87%       --    华北地区         --   99.18亿  2014-12-31   \n",
       "           qy         21.87%       --    华东地区         --   62.20亿  2014-12-31   \n",
       "           qy         17.08%       --      出口         --   48.58亿  2014-12-31   \n",
       "           qy          9.87%       --    西北地区         --   28.07亿  2014-12-31   \n",
       "           qy          5.43%       --    华南地区         --   15.44亿  2014-12-31   \n",
       "           qy          4.17%       --    东北地区         --   11.86亿  2014-12-31   \n",
       "           qy          4.11%       --    西南地区         --   11.69亿  2014-12-31   \n",
       "           qy          2.60%       --    中南地区         --    7.40亿  2014-12-31   \n",
       "\n",
       "                    classify  \n",
       "date       classify           \n",
       "2016-12-31 hy             hy  \n",
       "           hy             hy  \n",
       "           cp             cp  \n",
       "           cp             cp  \n",
       "           cp             cp  \n",
       "           cp             cp  \n",
       "           cp             cp  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "2016-06-30 hy             hy  \n",
       "           hy             hy  \n",
       "           cp             cp  \n",
       "           cp             cp  \n",
       "           cp             cp  \n",
       "           cp             cp  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "...                      ...  \n",
       "2015-12-31 qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "2015-06-30 hy             hy  \n",
       "           cp             cp  \n",
       "           cp             cp  \n",
       "           cp             cp  \n",
       "           cp             cp  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "2014-12-31 hy             hy  \n",
       "           hy             hy  \n",
       "           cp             cp  \n",
       "           cp             cp  \n",
       "           cp             cp  \n",
       "           cp             cp  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "           qy             qy  \n",
       "\n",
       "[73 rows x 13 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[2]"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
